{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"read":"whole","date_system":"1900"}

{"sheet":"Лист1","index":0,"n_rows":99,"n_cols":12,"rows_kept":99,"merged":[[0,2,0,4],[0,7,0,10],[1,7,1,10],[98,2,98,4]]}
["Школа",null,"МБОУ \"СОШ № 2\" НМР РТ",null,null,"Согласование:","должность","Директор"]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Кречетова Е.М."]
["Возрастная категория",{"$nulls":3},"7-11 лет",null,"дата",4,3,2024]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","гор.блюдо","Котлеты домашние с гречкой",90,8.01,11.14,35.71,248]
[{"$nulls":3},"гарнир","Макаронные изделия (рожки) отварные с маслом сливочным",153,5.68,2.88,31.96,176.1]
[{"$nulls":3},"доп. гарнир","яйцо варенное",40,5.08,4.6,0.28,63]
[{"$nulls":3},"напиток","Чай с сахаром",200,0.07,0.02,{"v":8,"d":"8.00"},32]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",20,1.32,0.24,7.92,39.6]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F6:F12)","v":503},{"$f":"SUM(G6:G12)","v":20.16},{"$f":"SUM(H6:H12)","v":18.879999999999995},{"$f":"SUM(I6:I12)","v":83.87},{"$f":"SUM(J6:J12)","v":558.7},null,80.66]
[1,2,"Завтрак","гор.блюдо","Биточки куриные Солнышко",90,6.01,11.53,12.88,183.45]
[{"$nulls":3},"гарнир","Каша пшеничная вязкая с маслом сливочным",153,6.7,4.38,35.99,227]
[{"$nulls":3},"напиток","кофейный напиток с молоком",200,3.17,2.68,9.98,60.1]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",30,2.28,0.24,14.76,70.5]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",30,1.98,0.36,11.88,59.4]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F14:F20)","v":503},{"$f":"SUM(G14:G20)","v":20.14},{"$f":"SUM(H14:H20)","v":19.189999999999998},{"$f":"SUM(I14:I20)","v":85.49000000000001},{"$f":"SUM(J14:J20)","v":600.4499999999999},null,80.66]
[1,3,"Завтрак","гор.блюдо","Плов из куриной грудки",200,15.42,17.96,38.93,390.5]
[{"$nulls":3},"фрукты","Яблоко",100,0.4,0.4,9.8,47]
[{"$nulls":3},"напиток","Чай с сахаром и лимоном",200,0.13,0.02,8.2,34.02]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",30,2.28,0.24,14.76,70.5]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",20,1.32,0.24,7.92,39.6]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F22:F28)","v":550},{"$f":"SUM(G22:G28)","v":19.55},{"$f":"SUM(H22:H28)","v":18.859999999999996},{"$f":"SUM(I22:I28)","v":79.61000000000001},{"$f":"SUM(J22:J28)","v":581.62},null,80.66]
[1,4,"Завтрак","гор.блюдо","Овощи тушенные с мясом",200,14.05,15.97,32.8,374.45]
[{"$nulls":3},"доп. гарнир","Капуста квашенная",50,0.85,2.5,4.22,42.85]
[{"$nulls":3},"напиток","Напиток из урюка",200,0.75,0.06,15.95,68.52]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",30,2.28,0.24,14.76,70.5]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",30,1.98,0.36,11.88,59.4]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F30:F36)","v":510},{"$f":"SUM(G30:G36)","v":19.91},19.129999999999995,79.61,615.7199999999999,null,80.66]
[1,5,"Завтрак","фрукты","Яблоки","100",0.4,0.4,9.8,47]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",30,2.28,0.24,14.76,70.5]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной","30",1.98,0.36,11.88,59.4]
[{"$nulls":3},"гор.блюдо","Сырники из творога со сгущенным молоком","150",15.55,18.35,36.03,398.93]
[{"$nulls":3},"гор.напиток","Чай с сахаром ","200",0.07,0.02,8,32]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"F38+F39+F40+F41+F42","v":510},{"$f":"G38+G39+G40+G41+G42","v":20.28},19.37,80.47,607.83,null,80.66]
[1,6,"Завтрак","гор.блюдо","Запеканка картофельная с птицей",180,10.58,14.26,12.09,174.1]
[{"$nulls":3},"напиток","Напиток из сухофруктов",200,0.7,0.1,22.03,92.9]
[{"$nulls":3},"сладкое","Печенье",40,2.96,3.76,10.84,10.84]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",40,1.52,0.16,22.14,47]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",40,1.98,0.36,11.88,59.4]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F46:F52)","v":500},19.92,18.92,80.48,564.48,null,80.66]
[2,7,"Завтрак","гор.блюдо","Биточки рыбные",90,10.68,8.98,16.21,170.2]
[{"$nulls":3},"гарнир","Макаронные изделия (рожки) отварные с маслом сливочным",153,5.68,2.88,31.96,176.1]
[{"$nulls":3},"напиток","Чай с сахаром, с яблоком",200,0.11,0.06,8.97,36.68]
[{"$nulls":3},"хлеб ","Бутерброд с маслом сливочным",40,2.36,7.49,14.89,136]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",20,1.32,0.24,7.92,39.6]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F54:F60)","v":503},{"$f":"SUM(G54:G60)","v":20.15},{"$f":"SUM(H54:H60)","v":19.65},{"$f":"SUM(I54:I60)","v":79.95},{"$f":"SUM(J54:J60)","v":558.58},null,80.66]
[2,8,"Завтрак","гор.блюдо","Жаркое из птицы (куриных грудок)",200,17.01,18.47,41.76,473.54]
[{"$nulls":3},"фрукты","Яблоко",100,0.4,0.4,9.8,47]
[{"$nulls":3},"напиток","Чай с сахаром",200,0.07,0.02,8,32]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",20,1.32,0.24,7.92,39.6]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F62:F67)","v":520},{"$f":"SUM(G62:G67)","v":18.8},19.129999999999995,67.48,592.14,null,80.66]
[2,9,"Завтрак","гор.блюдо","Котлеты Здоровье из куриных грудок",90,11.2,10.96,24.82,229.63]
[{"$nulls":3},"гарнир","Каша гречневая вязкая с маслом сливочным",153,4.6,7.19,20.56,165.3]
[{"$nulls":3},"напиток","Чай с сахаром и лимоном",200,0.13,0.02,8.2,34.02]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",30,2.28,0.24,14.76,70.5]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",30,1.98,0.36,11.88,59.4]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F69:F75)","v":503},{"$f":"SUM(G69:G75)","v":20.19},{"$f":"SUM(H69:H75)","v":18.77},{"$f":"SUM(I69:I75)","v":80.22},{"$f":"SUM(J69:J75)","v":558.85},null,80.66]
[2,10,"Завтрак ","гор.блюдо","Тефтели мясные с геркулесом",90,11.56,11.01,7.86,159.59]
[{"$nulls":3},"гарнир","Пюре картофельное с маслом сливочным",153,3.09,6.98,12.48,157.55]
[{"$nulls":3},"напиток","Кисель",200,0.6,0.1,20.2,123.6]
[{"$nulls":3},"сладкое","Пряники",35,2.1,2.1,9.2,89.5]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",30,2.28,0.24,14.76,70.5]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F77:F83)","v":508},{"$f":"SUM(G77:G83)","v":19.630000000000003},{"$f":"SUM(H77:H83)","v":20.430000000000003},{"$f":"SUM(I77:I83)","v":64.5},{"$f":"SUM(J77:J83)","v":600.74},null,80.66]
[2,11,"Завтрак","гор.блюдо","Гуляш из куриной грудки",100,8.64,9.83,13.4,209.39]
[{"$nulls":3},"гарнир","Каша пшенная вязкая",150,4.18,5.01,23.94,157.5]
[{"$nulls":3},"фрукты","Яблоко",100,0.4,0.4,9.8,47]
[{"$nulls":3},"напиток","Какао с молоком",200,4.08,3.54,2.61,58.6]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",30,2.28,0.24,14.76,70.5]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F85:F89)","v":580},{"$f":"SUM(G84:G89)","v":39.21},{"$f":"SUM(H84:H89)","v":39.45},{"$f":"SUM(I84:I89)","v":129.01},{"$f":"SUM(J84:J89)","v":1143.73},null,{"$f":"SUM(L84:L89)","v":80.66}]
[2,12,"Завтрак","гор.блюдо","Котлета рубленная из куринной грудки",90,9.7,11.63,14.99,209.39]
[{"$nulls":3},"гарнир","Пюре гороховое с сливочным маслом",153,6.09,8.26,30.06,244.95]
[{"$nulls":3},"напиток","Чай с сахаром ",200,0.07,0.02,8,32]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",30,1.98,0.36,11.88,59.4]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",30,2.28,0.24,14.76,70.5]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F92:F96)","v":503},{"$f":"SUM(G91:G96)","v":59.33},{"$f":"SUM(H91:H96)","v":59.96000000000001},{"$f":"SUM(I91:I96)","v":208.7},{"$f":"SUM(J91:J96)","v":1759.97},null,{"$f":"SUM(L91:L96)","v":80.66}]
[null,null,"Среднее значение за период:",null,null,{"$f":"(F13+F21+F29+F37+F45+F53+F61+F68+F76+F84+F91+F98)/12","v":{"v":516.0833333333334,"d":"516"}},{"v":24.772499999999997,"d":"25"},{"v":24.311666666666667,"d":"24"},{"v":93.28250000000001,"d":"93"},{"v":728.5675,"d":"729"},0]